import pandas as pd

# arr1 = [0, 1, 2, 3, 4]
# s1 = pd.Series(arr1)
# print('s1:\n', s1)
#
# index1 = ['a', 'b', 'c', 'd', 'e']
# s2 = pd.Series(arr1, index1)
# print('s2:\n', s2)
#
# d1 = {'a': 1, 'b': 2, 'c': 3, 'd': 4}
# s3 = pd.Series(d1)
# print('s3:\n', s3)

df = pd.read_excel('请假模板.xlsx', 'Sheet1', index_col=None, na_values=['NA'])
df.to_excel('test.xlsx', 'sheet1')
print(df)
